UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HASecGqmBlweIMzRRe9ff/VXTxVfcQz18Q9HZxYtwvA='
WHERE
key_id = '0b08e6384734544f00283c0ea19ec9d25443689881f91378da39beb913363ff6'
AND (
token = 'HASecGqmBlweIMzRRe9ff/VXTxVfcQz18Q9HZxYtwvA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)