UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7VX57f6n7BCi/TMEPymk4glaZ4HSAaKjw7dj8u/+cXw='
WHERE
key_id = '00171bf629fdcd27397f6d3a411ececeae8a71298eb69bfe787ae00a9c0b5987'
AND (
token = '7VX57f6n7BCi/TMEPymk4glaZ4HSAaKjw7dj8u/+cXw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)