UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'CEmvKWGt1sY3x81Q0xZ/m6hUg0ulFi2eDZNFVwNWyvg='
WHERE
key_id = 'a2c90b4ccd867f32506ef909e916df7364c2a936899f984a4742dfdd75923a8f'
AND (
token = 'CEmvKWGt1sY3x81Q0xZ/m6hUg0ulFi2eDZNFVwNWyvg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)