UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'cqoz+7NxaDphKXtm14zkTiWAVJGnm1re8R6KoM7BwOU='
WHERE
key_id = 'b178f0296c0be4ac932bbf75ef62d0bdb1bbd0000d5e859691196fe79e8c07ba'
AND (
token = 'cqoz+7NxaDphKXtm14zkTiWAVJGnm1re8R6KoM7BwOU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)