UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'TxIJRevWDPw+gBEXIbPk62kS6eIEs4dJzL8UUWh9BWc='
WHERE
key_id = 'c89d0dcb650e5bc27517505ab816875b265179db4e0ebdc82c1d7deae8515898'
AND (
token = 'TxIJRevWDPw+gBEXIbPk62kS6eIEs4dJzL8UUWh9BWc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)