UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'k5vKlf9IQ5WO6iJB6SXyzAbVNtrdf64QyPL3YMNcFek='
WHERE
key_id = '0476f73a7d3250bc185b58f511b60cf7a479dbd8fbc8b45e1714b1dfde78d705'
AND (
token = 'k5vKlf9IQ5WO6iJB6SXyzAbVNtrdf64QyPL3YMNcFek='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)