UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'NIxrjYGSdiF00dVkB/7hHv26ruiUmdtd5/4mMZZ62wA='
WHERE
key_id = 'd0cb1a923724d76aa52199febaade8b4d7b8a99e6479b2cf5cfe6cba91999486'
AND (
token = 'NIxrjYGSdiF00dVkB/7hHv26ruiUmdtd5/4mMZZ62wA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)