UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8nHOKtX3takVEd8YuDkkWLY9wPDYOqRsHeCsYr0Bt4Y='
WHERE
key_id = 'e2420cbcdf8f0f227682058d68d02f3a74ab288e79a570ecd59febb66cd6f768'
AND (
token = '8nHOKtX3takVEd8YuDkkWLY9wPDYOqRsHeCsYr0Bt4Y='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)