UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'oD6jYomqF2GwmBRpmqi1t3x4v4AEQEqj0mjI7YixWDU='
WHERE
key_id = '3a7264a1e88811ff7b6ced08f70f716b2ebac46348780be0e2879aed264eef08'
AND (
token = 'oD6jYomqF2GwmBRpmqi1t3x4v4AEQEqj0mjI7YixWDU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)