UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'J6DfZHNv+3n8Tz6VcZEcoyiGlesNW7By6o1eYimAjZA='
WHERE
key_id = 'e45110694a67b6f68c5127b612335458c1097bd1e2322802ea64bc88a2a3edcc'
AND (
token = 'J6DfZHNv+3n8Tz6VcZEcoyiGlesNW7By6o1eYimAjZA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)