UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'z327xf3WDzdY2hD3twDCQlXltrAxmyQgDYH7yh7OiuQ='
WHERE
key_id = '74210e518998c05e99f821eb13fbc7c36e776052a8df031a80eac3e76e75ddd2'
AND (
token = 'z327xf3WDzdY2hD3twDCQlXltrAxmyQgDYH7yh7OiuQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)