UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'TApN419HeDIJDQTD1vKAPiMErW/M2kq0RH3Q/49BVoc='
WHERE
key_id = '8e2690ca6d4e164268489489395a440114a72f4a02e69de3b28904bb2df08496'
AND (
token = 'TApN419HeDIJDQTD1vKAPiMErW/M2kq0RH3Q/49BVoc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)