UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4K1KPmfs1y8DIU7iaLrpWQqlclOlLzRjEys/pbb+ZKA='
WHERE
key_id = 'f625a6e739301da98aaa58657a4ed08ff8058e47f9653fc4acaec15aee93523f'
AND (
token = '4K1KPmfs1y8DIU7iaLrpWQqlclOlLzRjEys/pbb+ZKA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)