UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BkOgaX9gHnDqd6936G7nx5I+P4WTfu+wOkVaGENZYcw='
WHERE
key_id = 'd54fac3c7b8c9ffdf6dcfc6b6750a0d8567d84cc46e1c467ec534a7f8b6346a1'
AND (
token = 'BkOgaX9gHnDqd6936G7nx5I+P4WTfu+wOkVaGENZYcw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)