UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'tJ1whzahWj2awUf2c+T4xxKUtk2GlZMS5Gur3tdvaas='
WHERE
key_id = '2ae9097e93fcef9bae497f8a6e5d20133189ccb5ae921ca3c1ac4e3a1787064c'
AND (
token = 'tJ1whzahWj2awUf2c+T4xxKUtk2GlZMS5Gur3tdvaas='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)