UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'eK7y96YFa00cFDMbEP7OuVxgX//PX6+JQE4UhFlO1mY='
WHERE
key_id = 'ac859573e2143ef70a0a7d57314a8fc11ec5f40b43d9ab4eb284916575164fda'
AND (
token = 'eK7y96YFa00cFDMbEP7OuVxgX//PX6+JQE4UhFlO1mY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)