UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'KcoFF6q6EJLeFniTaBbA9jI9gBlf0PW3df38wtHUCBE='
WHERE
key_id = '549865a27dbc8dc4d14e3f158250d00e737d80e7c65400c7a0e66d9b8dabeae8'
AND (
token = 'KcoFF6q6EJLeFniTaBbA9jI9gBlf0PW3df38wtHUCBE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)