UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'k6+SJJ8bzhuhFE2ycaWTihCh1ccEuzkV9zp3JXY8Wsc='
WHERE
key_id = '40c29e283326b09e2d8c7bd0d490449279f7148611d346f90f940f234de4a235'
AND (
token = 'k6+SJJ8bzhuhFE2ycaWTihCh1ccEuzkV9zp3JXY8Wsc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)