UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'cMpZo5mG3v82g/2XUSE/Ce5Tx8perHF4ZrMdVPgDuf8='
WHERE
key_id = '2cfd47dbeaa3c7d327327878a25fbc52b8091139d90fa5b98d079c3e6e30bd0b'
AND (
token = 'cMpZo5mG3v82g/2XUSE/Ce5Tx8perHF4ZrMdVPgDuf8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)