UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1BvcX+jJIYG+Q6/8XH6xGXMM9xzLG0yAOHxk9mteriI='
WHERE
key_id = '7fa428c3e34dc278443cf6201a8f4d788c5b92a4c89034685fa8394eaedaa6a3'
AND (
token = '1BvcX+jJIYG+Q6/8XH6xGXMM9xzLG0yAOHxk9mteriI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)