UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zWXSwAlAbSy6WXVx48Ghj4EXUKKT0VZGpk2OYNTIdSY='
WHERE
key_id = '8a0c7be89104ef139ba4325e3b905720019111facde8782e9f38636781c76498'
AND (
token = 'zWXSwAlAbSy6WXVx48Ghj4EXUKKT0VZGpk2OYNTIdSY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)