UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6rKNc0reCYq0UVAWLV49hilIxoEcb5AjRq0CmGWf2go='
WHERE
key_id = 'fc97d6cdb03c4c66fbc19108a00d794ced2b1ff250051dcf49bcca8b7eeb2947'
AND (
token = '6rKNc0reCYq0UVAWLV49hilIxoEcb5AjRq0CmGWf2go='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)