UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'TzFNr1hx/jbrjaXyg20nYZaInM63XqC1isGmuW8DOew='
WHERE
key_id = '5868b9dff590bcd4aa7a628728a8aab70be79923948d40d1faffe8c5fabc22db'
AND (
token = 'TzFNr1hx/jbrjaXyg20nYZaInM63XqC1isGmuW8DOew='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)