UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'CTMKvKuVGnhEvvfJP54dMvaMrMC1bz6ejCehOZK0uTw='
WHERE
key_id = '1502f7f37361e8d1c88ec38acc80eef297710f3ba0b2ce88c88142cfea37f029'
AND (
token = 'CTMKvKuVGnhEvvfJP54dMvaMrMC1bz6ejCehOZK0uTw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)