UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0sQqYWuRDpFqsJ0QqKUcMAI8CX3AY352J8cHSiqdyvY='
WHERE
key_id = '8c828413e3b5b6fc9735ebc0b3a79f217ac5308b11c03c42f486e003aaf43a31'
AND (
token = '0sQqYWuRDpFqsJ0QqKUcMAI8CX3AY352J8cHSiqdyvY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)