UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'K1gTnU8b3lKm3UbZkTPdPpI4iCusviW70eDYluU5SCQ='
WHERE
key_id = '8ad1a7b5410ddfbc4ba08c10856f963b737e5ba9cfaf146ed64d0897859190b7'
AND (
token = 'K1gTnU8b3lKm3UbZkTPdPpI4iCusviW70eDYluU5SCQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)