UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9Fvs3sgjBkJvayRnRLUsSIhvRxQCJb7W1nGrRdEztI8='
WHERE
key_id = '3a8d44d9d0c923bb7b5a57a5fd03e5f1e656abc8d87999df1483b30cae580ab2'
AND (
token = '9Fvs3sgjBkJvayRnRLUsSIhvRxQCJb7W1nGrRdEztI8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)