UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'codQc0P6ofevyxLMwhXo5+an+sQPicESFZiKqQrwktA='
WHERE
key_id = '84d49e57b2eac9dd36946647bba1722061f33957942b67e96cedb0eef0aecfcb'
AND (
token = 'codQc0P6ofevyxLMwhXo5+an+sQPicESFZiKqQrwktA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)