UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'uZctUoLamwU9NiSPkbffI0U1HNHF1NRHGbqg0oJp6Co='
WHERE
key_id = 'bd524174f9696e2cd0ed7e1def2abc828791ca48ffe06da242448136f83f8d1f'
AND (
token = 'uZctUoLamwU9NiSPkbffI0U1HNHF1NRHGbqg0oJp6Co='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)