UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pZrMwP/YEZ2qEC2xXjrtfja0iySiSf2ZlCwIdVSviYc='
WHERE
key_id = '2714fd538e64dab044292005c96d1980430332ef05532e8d27c757540568cb9c'
AND (
token = 'pZrMwP/YEZ2qEC2xXjrtfja0iySiSf2ZlCwIdVSviYc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)